Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
PromotionalOfferID (PK) | The unique identifier for a promotion. | ID_PRM_OFR | Identity | integer | |
PromotionalInitiativeID (FK)(PK) | A token ID for a retailer's PromotionInitiative instance. | ID_PRML_INITV | Identity | integer | |
BusinessUnitGroupID (FK) | A unique system assigned identifier for the BusinessUnitGroup at which the Promotion is valid. | ID_BSNGP | Identity | integer | BusinessUnitGroup(CO_BSNGP) |
EffectiveDate | The first date and time that this promotion is effective. | DT_PRM_EF | EffectiveDateTime | datetime | |
ExpiryDate | The last date and time that this promotion is effective. | DT_PRM_EP | ExpirationDateTime | datetime | |
MultipleEligibilityCombinationCode | When a promotion consists of more than one pairing of PriceDerivationRuleEligibility and PriceDerivationRule then how are the multiple pairings to be combined. | CD_MLP_EL | Code2 | char(2) | |
ConcurrenceCode | A code denoting how this promotion works in relation to other promotions. Sample values: STAND_ALONE - Promotion applies only if no other promotions are applied JOINT - Promotioin applies along with others | TY_CNCRN | Code2 | char(2) | |
UpSellTypeCode | A code that indicates how up selling is to be performed. | TY_UP_SELL | Code2 | char(2) | |
OperatorDisplayName | Text to be displayed to the Operator. | NM_PRM_OPR | Name | varchar(40) | |
CustomerDisplayName | Text to be displayed to the customer. | NM_PRM_CT | Name | varchar(40) | |
ReceiptPrinterName | Text to be printed on the receipt | NM_PRM_PRT | Name | varchar(40) | |
AccountingDispositionCode | A code that determines how the price change made as a result of this PROMOTION is to be treated for stock ledger accounting purposes. This code allows price change modifiers to be treated as discounts/surcharges (expenses below the gross margin line) OR as markdowns (treated as changes to the inventory value which alter the stock ledger's cumulative markon for the item). | DP_ACNT | Code4 | char(4) | |
StatusCode | Indicates the current status of this PromotionalOffer. Example values are: A - Active I - Inactive P - Pending C - Canceled. | CD_STS_PRM | Code2Status | char(2) | |
CustomerRewardProgramTierCode (FK) | A code that represents the relative value of a given CustomerRewardProgramTier | CD_CT_RWD_PRGM_TR | Code | varchar(20) | CustomerMembershipEarnedRewardTier(CO_CT_MBRSHP_ERN_RWD_TIER) |
MembershipProgramID (FK) | Token ID for a CustomerRewardProgram instance. | ID_CT_MBRSHP_PRGM | Identity | integer | CustomerMembershipEarnedRewardTier(CO_CT_MBRSHP_ERN_RWD_TIER) |
LevelNumber (FK) | A whole number that establishes the relative value of a membership program level. The higher the value, the greater the level and its associated rewards and, where applicable, fees. | IC_LV_NMB | Number | integer | CustomerMembershipEarnedRewardTier(CO_CT_MBRSHP_ERN_RWD_TIER) |